1 | SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 0 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
3 | SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 0 |
4 | SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 0 |
5 | SHOW FULL COLUMNS FROM `configurations` | | 5 | 5 | 0 |
6 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'DEFAULT_THEME' LIMIT 1 | | 1 | 1 | 0 |
7 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'FOOTER' LIMIT 1 | | 1 | 1 | 0 |
8 | SHOW FULL COLUMNS FROM `currencies` | | 8 | 8 | 0 |
9 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'DEFAULT_CURRENCY' LIMIT 1 | | 1 | 1 | 0 |
10 | SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`iso_code`, `Currency`.`sign`, `Currency`.`format`, `Currency`.`decimals`, `Currency`.`blank`, `Currency`.`conversion_rate` FROM `currencies` AS `Currency` WHERE `Currency`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
11 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CERTIFICATE_ID' LIMIT 1 | | 1 | 1 | 0 |
12 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_NAME' LIMIT 1 | | 1 | 1 | 0 |
13 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_ADRESS' LIMIT 1 | | 1 | 1 | 0 |
14 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_POSTCODE' LIMIT 1 | | 1 | 1 | 0 |
15 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_CITY' LIMIT 1 | | 1 | 1 | 0 |
16 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_TEL' LIMIT 1 | | 1 | 1 | 0 |
17 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`updated` FROM `configurations` AS `Configuration` WHERE `Configuration`.`name` = 'CONTACT_MOBILE' LIMIT 1 | | 1 | 1 | 0 |
18 | SHOW FULL COLUMNS FROM `adverts` | | 3 | 3 | 0 |
19 | SELECT `Advert`.`id`, `Advert`.`image`, `Advert`.`url` FROM `adverts` AS `Advert` WHERE 1 = 1 ORDER BY `Advert`.`id` desc | | 1 | 1 | 0 |
20 | SHOW FULL COLUMNS FROM `tags` | | 3 | 3 | 0 |
21 | SHOW FULL COLUMNS FROM `products` | | 23 | 23 | 0 |
22 | SHOW FULL COLUMNS FROM `categories` | | 8 | 8 | 0 |
23 | SHOW FULL COLUMNS FROM `suppliers` | | 8 | 8 | 0 |
24 | SHOW FULL COLUMNS FROM `taxes` | | 3 | 3 | 0 |
25 | SHOW FULL COLUMNS FROM `product_images` | | 6 | 6 | 0 |
26 | SHOW FULL COLUMNS FROM `product_attributes` | | 4 | 4 | 0 |
27 | SHOW FULL COLUMNS FROM `attributes` | | 4 | 4 | 0 |
28 | SHOW FULL COLUMNS FROM `product_properties` | | 5 | 5 | 0 |
29 | SHOW FULL COLUMNS FROM `property_groups` | | 3 | 3 | 0 |
30 | SHOW FULL COLUMNS FROM `properties` | | 3 | 3 | 0 |
31 | SHOW FULL COLUMNS FROM `product_attachments` | | 3 | 3 | 0 |
32 | SHOW FULL COLUMNS FROM `attachments` | | 4 | 4 | 0 |
33 | SHOW FULL COLUMNS FROM `related_products` | | 3 | 3 | 0 |
34 | SHOW FULL COLUMNS FROM `product_tags` | | 3 | 3 | 0 |
35 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`product_count` FROM `tags` AS `Tag` WHERE 1 = 1 ORDER BY `Tag`.`id` asc | | 9 | 9 | 0 |
36 | SELECT `Product`.`id`, `Product`.`name`, `ProductTag`.`id`, `ProductTag`.`product_id`, `ProductTag`.`tag_id` FROM `products` AS `Product` JOIN `product_tags` AS `ProductTag` ON (`ProductTag`.`tag_id` IN (1, 2, 3, 5, 6, 7, 8, 9, 10) AND `ProductTag`.`product_id` = `Product`.`id`) | | 369 | 369 | 1 |
37 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`active`, `Category`.`list`, `Category`.`slided`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 4 | | 7 | 7 | 0 |
38 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`active`, `Category`.`list`, `Category`.`slided`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 5 | | 3 | 3 | 0 |
39 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`active`, `Category`.`list`, `Category`.`slided`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 7 | | 7 | 7 | 0 |
40 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`active`, `Category`.`list`, `Category`.`slided`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 9 | | 3 | 3 | 0 |
41 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`active`, `Category`.`list`, `Category`.`slided`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 15 | | 0 | 0 | 0 |